﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsSearch" targetNamespace="http://tempuri.org/dsSearch.xsd" xmlns:mstns="http://tempuri.org/dsSearch.xsd" xmlns="http://tempuri.org/dsSearch.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="constrMovieMgr" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="constrMovieMgr (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.EntertainmentManager.My.MySettings.GlobalReference.Default.constrMovieMgr" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MuveeDetailsViewTableAdapter" GeneratorDataComponentClassName="MuveeDetailsViewTableAdapter" Name="MuveeDetailsView" UserDataComponentName="MuveeDetailsViewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="constrMovieMgr (MySettings)" DbObjectName="MovieMgr.dbo.MuveeDetailsView" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT PKey, StagePKey, SerialNo, tmpLoaned, Title, AlternateTitle, ID, tmpSeen, Seen, Rating, MyRating, tmpDirector, Director, Volume, Genre, Year, Studio, Collection, Cast, Plot, Notes, Country, Poster, PosterLocation, Classification, nDiscs, RunTime, Layer, Colour, Region, Medium, VCodec, ACodec, Condition, IMDbLink, IMDbTrailerLink, OfficialSite, WikipediaLink, MyReviews, Status, VolumeMainPKey, CollectionMainPKey, LayerMainPKey, ColourMainPKey, RegionMainPKey, MediumMainPKey, VCodecMainPKey, ACodecMainPKey, CondMainPKey, RelDirectorPKey FROM dbo.MuveeDetailsView</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKey" DataSetColumn="PKey" />
              <Mapping SourceColumn="StagePKey" DataSetColumn="StagePKey" />
              <Mapping SourceColumn="SerialNo" DataSetColumn="SerialNo" />
              <Mapping SourceColumn="tmpLoaned" DataSetColumn="tmpLoaned" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="AlternateTitle" DataSetColumn="AlternateTitle" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="tmpSeen" DataSetColumn="tmpSeen" />
              <Mapping SourceColumn="Seen" DataSetColumn="Seen" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="MyRating" DataSetColumn="MyRating" />
              <Mapping SourceColumn="tmpDirector" DataSetColumn="tmpDirector" />
              <Mapping SourceColumn="Director" DataSetColumn="Director" />
              <Mapping SourceColumn="Volume" DataSetColumn="Volume" />
              <Mapping SourceColumn="Genre" DataSetColumn="Genre" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="Studio" DataSetColumn="Studio" />
              <Mapping SourceColumn="Collection" DataSetColumn="Collection" />
              <Mapping SourceColumn="Cast" DataSetColumn="Cast" />
              <Mapping SourceColumn="Plot" DataSetColumn="Plot" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="Poster" DataSetColumn="Poster" />
              <Mapping SourceColumn="PosterLocation" DataSetColumn="PosterLocation" />
              <Mapping SourceColumn="Classification" DataSetColumn="Classification" />
              <Mapping SourceColumn="nDiscs" DataSetColumn="nDiscs" />
              <Mapping SourceColumn="RunTime" DataSetColumn="RunTime" />
              <Mapping SourceColumn="Layer" DataSetColumn="Layer" />
              <Mapping SourceColumn="Colour" DataSetColumn="Colour" />
              <Mapping SourceColumn="Region" DataSetColumn="Region" />
              <Mapping SourceColumn="Medium" DataSetColumn="Medium" />
              <Mapping SourceColumn="VCodec" DataSetColumn="VCodec" />
              <Mapping SourceColumn="ACodec" DataSetColumn="ACodec" />
              <Mapping SourceColumn="Condition" DataSetColumn="Condition" />
              <Mapping SourceColumn="IMDbLink" DataSetColumn="IMDbLink" />
              <Mapping SourceColumn="IMDbTrailerLink" DataSetColumn="IMDbTrailerLink" />
              <Mapping SourceColumn="OfficialSite" DataSetColumn="OfficialSite" />
              <Mapping SourceColumn="WikipediaLink" DataSetColumn="WikipediaLink" />
              <Mapping SourceColumn="MyReviews" DataSetColumn="MyReviews" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="VolumeMainPKey" DataSetColumn="VolumeMainPKey" />
              <Mapping SourceColumn="CollectionMainPKey" DataSetColumn="CollectionMainPKey" />
              <Mapping SourceColumn="LayerMainPKey" DataSetColumn="LayerMainPKey" />
              <Mapping SourceColumn="ColourMainPKey" DataSetColumn="ColourMainPKey" />
              <Mapping SourceColumn="RegionMainPKey" DataSetColumn="RegionMainPKey" />
              <Mapping SourceColumn="MediumMainPKey" DataSetColumn="MediumMainPKey" />
              <Mapping SourceColumn="VCodecMainPKey" DataSetColumn="VCodecMainPKey" />
              <Mapping SourceColumn="ACodecMainPKey" DataSetColumn="ACodecMainPKey" />
              <Mapping SourceColumn="CondMainPKey" DataSetColumn="CondMainPKey" />
              <Mapping SourceColumn="RelDirectorPKey" DataSetColumn="RelDirectorPKey" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SeriesDetailsViewTableAdapter" GeneratorDataComponentClassName="SeriesDetailsViewTableAdapter" Name="SeriesDetailsView" UserDataComponentName="SeriesDetailsViewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="constrMovieMgr (MySettings)" DbObjectName="MovieMgr.dbo.SeriesDetailsView" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT PKey, StagePKey, SerialNo, tmpSeen, tmpLoaned, Title, AlternateTitle, ID, Seen, Rating, MyRating, tmpDirector, Director, Volume, Genre, Year, Studio, Collection, Cast, Plot, Notes, Country, Poster, PosterLocation, Classification, nDiscs, RunTime, Layer, Colour, Region, Medium, VCodec, ACodec, Condition, IMDbLink, IMDbTrailerLink, OfficialSite, WikipediaLink, MyReviews, Status, VolumeMainPKey, CollectionMainPKey, LayerMainPKey, ColourMainPKey, RegionMainPKey, MediumMainPKey, VCodecMainPKey, ACodecMainPKey, CondMainPKey FROM dbo.SeriesDetailsView</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PKey" DataSetColumn="PKey" />
              <Mapping SourceColumn="StagePKey" DataSetColumn="StagePKey" />
              <Mapping SourceColumn="SerialNo" DataSetColumn="SerialNo" />
              <Mapping SourceColumn="tmpSeen" DataSetColumn="tmpSeen" />
              <Mapping SourceColumn="tmpLoaned" DataSetColumn="tmpLoaned" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="AlternateTitle" DataSetColumn="AlternateTitle" />
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Seen" DataSetColumn="Seen" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="MyRating" DataSetColumn="MyRating" />
              <Mapping SourceColumn="tmpDirector" DataSetColumn="tmpDirector" />
              <Mapping SourceColumn="Director" DataSetColumn="Director" />
              <Mapping SourceColumn="Volume" DataSetColumn="Volume" />
              <Mapping SourceColumn="Genre" DataSetColumn="Genre" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="Studio" DataSetColumn="Studio" />
              <Mapping SourceColumn="Collection" DataSetColumn="Collection" />
              <Mapping SourceColumn="Cast" DataSetColumn="Cast" />
              <Mapping SourceColumn="Plot" DataSetColumn="Plot" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="Country" DataSetColumn="Country" />
              <Mapping SourceColumn="Poster" DataSetColumn="Poster" />
              <Mapping SourceColumn="PosterLocation" DataSetColumn="PosterLocation" />
              <Mapping SourceColumn="Classification" DataSetColumn="Classification" />
              <Mapping SourceColumn="nDiscs" DataSetColumn="nDiscs" />
              <Mapping SourceColumn="RunTime" DataSetColumn="RunTime" />
              <Mapping SourceColumn="Layer" DataSetColumn="Layer" />
              <Mapping SourceColumn="Colour" DataSetColumn="Colour" />
              <Mapping SourceColumn="Region" DataSetColumn="Region" />
              <Mapping SourceColumn="Medium" DataSetColumn="Medium" />
              <Mapping SourceColumn="VCodec" DataSetColumn="VCodec" />
              <Mapping SourceColumn="ACodec" DataSetColumn="ACodec" />
              <Mapping SourceColumn="Condition" DataSetColumn="Condition" />
              <Mapping SourceColumn="IMDbLink" DataSetColumn="IMDbLink" />
              <Mapping SourceColumn="IMDbTrailerLink" DataSetColumn="IMDbTrailerLink" />
              <Mapping SourceColumn="OfficialSite" DataSetColumn="OfficialSite" />
              <Mapping SourceColumn="WikipediaLink" DataSetColumn="WikipediaLink" />
              <Mapping SourceColumn="MyReviews" DataSetColumn="MyReviews" />
              <Mapping SourceColumn="Status" DataSetColumn="Status" />
              <Mapping SourceColumn="VolumeMainPKey" DataSetColumn="VolumeMainPKey" />
              <Mapping SourceColumn="CollectionMainPKey" DataSetColumn="CollectionMainPKey" />
              <Mapping SourceColumn="LayerMainPKey" DataSetColumn="LayerMainPKey" />
              <Mapping SourceColumn="ColourMainPKey" DataSetColumn="ColourMainPKey" />
              <Mapping SourceColumn="RegionMainPKey" DataSetColumn="RegionMainPKey" />
              <Mapping SourceColumn="MediumMainPKey" DataSetColumn="MediumMainPKey" />
              <Mapping SourceColumn="VCodecMainPKey" DataSetColumn="VCodecMainPKey" />
              <Mapping SourceColumn="ACodecMainPKey" DataSetColumn="ACodecMainPKey" />
              <Mapping SourceColumn="CondMainPKey" DataSetColumn="CondMainPKey" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsSearch" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsSearch" msprop:Generator_DataSetName="dsSearch">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="MuveeDetailsView" msprop:Generator_UserTableName="MuveeDetailsView" msprop:Generator_RowDeletedName="MuveeDetailsViewRowDeleted" msprop:Generator_RowChangedName="MuveeDetailsViewRowChanged" msprop:Generator_RowClassName="MuveeDetailsViewRow" msprop:Generator_RowChangingName="MuveeDetailsViewRowChanging" msprop:Generator_RowEvArgName="MuveeDetailsViewRowChangeEvent" msprop:Generator_RowEvHandlerName="MuveeDetailsViewRowChangeEventHandler" msprop:Generator_TableClassName="MuveeDetailsViewDataTable" msprop:Generator_TableVarName="tableMuveeDetailsView" msprop:Generator_RowDeletingName="MuveeDetailsViewRowDeleting" msprop:Generator_TablePropName="MuveeDetailsView">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKey" msprop:Generator_UserColumnName="PKey" msprop:Generator_ColumnPropNameInRow="PKey" msprop:Generator_ColumnVarNameInTable="columnPKey" msprop:Generator_ColumnPropNameInTable="PKeyColumn" type="xs:int" />
              <xs:element name="StagePKey" msprop:Generator_UserColumnName="StagePKey" msprop:Generator_ColumnPropNameInRow="StagePKey" msprop:Generator_ColumnVarNameInTable="columnStagePKey" msprop:Generator_ColumnPropNameInTable="StagePKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SerialNo" msprop:Generator_UserColumnName="SerialNo" msprop:Generator_ColumnPropNameInRow="SerialNo" msprop:Generator_ColumnVarNameInTable="columnSerialNo" msprop:Generator_ColumnPropNameInTable="SerialNoColumn" type="xs:int" />
              <xs:element name="tmpLoaned" msprop:Generator_UserColumnName="tmpLoaned" msprop:Generator_ColumnPropNameInRow="tmpLoaned" msprop:Generator_ColumnVarNameInTable="columntmpLoaned" msprop:Generator_ColumnPropNameInTable="tmpLoanedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AlternateTitle" msprop:Generator_UserColumnName="AlternateTitle" msprop:Generator_ColumnPropNameInRow="AlternateTitle" msprop:Generator_ColumnVarNameInTable="columnAlternateTitle" msprop:Generator_ColumnPropNameInTable="AlternateTitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tmpSeen" msdata:ReadOnly="true" msprop:Generator_UserColumnName="tmpSeen" msprop:Generator_ColumnPropNameInRow="tmpSeen" msprop:Generator_ColumnVarNameInTable="columntmpSeen" msprop:Generator_ColumnPropNameInTable="tmpSeenColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Seen" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Seen" msprop:Generator_ColumnPropNameInRow="Seen" msprop:Generator_ColumnVarNameInTable="columnSeen" msprop:Generator_ColumnPropNameInTable="SeenColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInTable="RatingColumn" type="xs:double" minOccurs="0" />
              <xs:element name="MyRating" msprop:Generator_UserColumnName="MyRating" msprop:Generator_ColumnPropNameInRow="MyRating" msprop:Generator_ColumnVarNameInTable="columnMyRating" msprop:Generator_ColumnPropNameInTable="MyRatingColumn" type="xs:double" minOccurs="0" />
              <xs:element name="tmpDirector" msprop:Generator_UserColumnName="tmpDirector" msprop:Generator_ColumnPropNameInRow="tmpDirector" msprop:Generator_ColumnVarNameInTable="columntmpDirector" msprop:Generator_ColumnPropNameInTable="tmpDirectorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Director" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Director" msprop:Generator_ColumnPropNameInRow="Director" msprop:Generator_ColumnVarNameInTable="columnDirector" msprop:Generator_ColumnPropNameInTable="DirectorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Volume" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Volume" msprop:Generator_ColumnPropNameInRow="Volume" msprop:Generator_ColumnVarNameInTable="columnVolume" msprop:Generator_ColumnPropNameInTable="VolumeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Genre" msprop:Generator_UserColumnName="Genre" msprop:Generator_ColumnPropNameInRow="Genre" msprop:Generator_ColumnVarNameInTable="columnGenre" msprop:Generator_ColumnPropNameInTable="GenreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Studio" msprop:Generator_UserColumnName="Studio" msprop:Generator_ColumnPropNameInRow="Studio" msprop:Generator_ColumnVarNameInTable="columnStudio" msprop:Generator_ColumnPropNameInTable="StudioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Collection" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Collection" msprop:Generator_ColumnPropNameInRow="Collection" msprop:Generator_ColumnVarNameInTable="columnCollection" msprop:Generator_ColumnPropNameInTable="CollectionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cast" msprop:Generator_UserColumnName="Cast" msprop:Generator_ColumnPropNameInRow="Cast" msprop:Generator_ColumnVarNameInTable="columnCast" msprop:Generator_ColumnPropNameInTable="CastColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Plot" msprop:Generator_UserColumnName="Plot" msprop:Generator_ColumnPropNameInRow="Plot" msprop:Generator_ColumnVarNameInTable="columnPlot" msprop:Generator_ColumnPropNameInTable="PlotColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_UserColumnName="Notes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInTable="NotesColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Poster" msprop:Generator_UserColumnName="Poster" msprop:Generator_ColumnPropNameInRow="Poster" msprop:Generator_ColumnVarNameInTable="columnPoster" msprop:Generator_ColumnPropNameInTable="PosterColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PosterLocation" msprop:Generator_UserColumnName="PosterLocation" msprop:Generator_ColumnPropNameInRow="PosterLocation" msprop:Generator_ColumnVarNameInTable="columnPosterLocation" msprop:Generator_ColumnPropNameInTable="PosterLocationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Classification" msprop:Generator_UserColumnName="Classification" msprop:Generator_ColumnPropNameInRow="Classification" msprop:Generator_ColumnVarNameInTable="columnClassification" msprop:Generator_ColumnPropNameInTable="ClassificationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nDiscs" msprop:Generator_UserColumnName="nDiscs" msprop:Generator_ColumnPropNameInRow="nDiscs" msprop:Generator_ColumnVarNameInTable="columnnDiscs" msprop:Generator_ColumnPropNameInTable="nDiscsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RunTime" msprop:Generator_UserColumnName="RunTime" msprop:Generator_ColumnPropNameInRow="RunTime" msprop:Generator_ColumnVarNameInTable="columnRunTime" msprop:Generator_ColumnPropNameInTable="RunTimeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Layer" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Layer" msprop:Generator_ColumnPropNameInRow="Layer" msprop:Generator_ColumnVarNameInTable="columnLayer" msprop:Generator_ColumnPropNameInTable="LayerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Colour" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Colour" msprop:Generator_ColumnPropNameInRow="Colour" msprop:Generator_ColumnVarNameInTable="columnColour" msprop:Generator_ColumnPropNameInTable="ColourColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Region" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Region" msprop:Generator_ColumnPropNameInRow="_Region" msprop:Generator_ColumnVarNameInTable="columnRegion" msprop:Generator_ColumnPropNameInTable="RegionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Medium" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Medium" msprop:Generator_ColumnPropNameInRow="Medium" msprop:Generator_ColumnVarNameInTable="columnMedium" msprop:Generator_ColumnPropNameInTable="MediumColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VCodec" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VCodec" msprop:Generator_ColumnPropNameInRow="VCodec" msprop:Generator_ColumnVarNameInTable="columnVCodec" msprop:Generator_ColumnPropNameInTable="VCodecColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACodec" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ACodec" msprop:Generator_ColumnPropNameInRow="ACodec" msprop:Generator_ColumnVarNameInTable="columnACodec" msprop:Generator_ColumnPropNameInTable="ACodecColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Condition" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Condition" msprop:Generator_ColumnPropNameInRow="Condition" msprop:Generator_ColumnVarNameInTable="columnCondition" msprop:Generator_ColumnPropNameInTable="ConditionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMDbLink" msdata:ReadOnly="true" msprop:Generator_UserColumnName="IMDbLink" msprop:Generator_ColumnPropNameInRow="IMDbLink" msprop:Generator_ColumnVarNameInTable="columnIMDbLink" msprop:Generator_ColumnPropNameInTable="IMDbLinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMDbTrailerLink" msdata:ReadOnly="true" msprop:Generator_UserColumnName="IMDbTrailerLink" msprop:Generator_ColumnPropNameInRow="IMDbTrailerLink" msprop:Generator_ColumnVarNameInTable="columnIMDbTrailerLink" msprop:Generator_ColumnPropNameInTable="IMDbTrailerLinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OfficialSite" msdata:ReadOnly="true" msprop:Generator_UserColumnName="OfficialSite" msprop:Generator_ColumnPropNameInRow="OfficialSite" msprop:Generator_ColumnVarNameInTable="columnOfficialSite" msprop:Generator_ColumnPropNameInTable="OfficialSiteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WikipediaLink" msdata:ReadOnly="true" msprop:Generator_UserColumnName="WikipediaLink" msprop:Generator_ColumnPropNameInRow="WikipediaLink" msprop:Generator_ColumnVarNameInTable="columnWikipediaLink" msprop:Generator_ColumnPropNameInTable="WikipediaLinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MyReviews" msprop:Generator_UserColumnName="MyReviews" msprop:Generator_ColumnPropNameInRow="MyReviews" msprop:Generator_ColumnVarNameInTable="columnMyReviews" msprop:Generator_ColumnPropNameInTable="MyReviewsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VolumeMainPKey" msprop:Generator_UserColumnName="VolumeMainPKey" msprop:Generator_ColumnPropNameInRow="VolumeMainPKey" msprop:Generator_ColumnVarNameInTable="columnVolumeMainPKey" msprop:Generator_ColumnPropNameInTable="VolumeMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CollectionMainPKey" msprop:Generator_UserColumnName="CollectionMainPKey" msprop:Generator_ColumnPropNameInRow="CollectionMainPKey" msprop:Generator_ColumnVarNameInTable="columnCollectionMainPKey" msprop:Generator_ColumnPropNameInTable="CollectionMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="LayerMainPKey" msprop:Generator_UserColumnName="LayerMainPKey" msprop:Generator_ColumnPropNameInRow="LayerMainPKey" msprop:Generator_ColumnVarNameInTable="columnLayerMainPKey" msprop:Generator_ColumnPropNameInTable="LayerMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ColourMainPKey" msprop:Generator_UserColumnName="ColourMainPKey" msprop:Generator_ColumnPropNameInRow="ColourMainPKey" msprop:Generator_ColumnVarNameInTable="columnColourMainPKey" msprop:Generator_ColumnPropNameInTable="ColourMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RegionMainPKey" msprop:Generator_UserColumnName="RegionMainPKey" msprop:Generator_ColumnPropNameInRow="RegionMainPKey" msprop:Generator_ColumnVarNameInTable="columnRegionMainPKey" msprop:Generator_ColumnPropNameInTable="RegionMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MediumMainPKey" msprop:Generator_UserColumnName="MediumMainPKey" msprop:Generator_ColumnPropNameInRow="MediumMainPKey" msprop:Generator_ColumnVarNameInTable="columnMediumMainPKey" msprop:Generator_ColumnPropNameInTable="MediumMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="VCodecMainPKey" msprop:Generator_UserColumnName="VCodecMainPKey" msprop:Generator_ColumnPropNameInRow="VCodecMainPKey" msprop:Generator_ColumnVarNameInTable="columnVCodecMainPKey" msprop:Generator_ColumnPropNameInTable="VCodecMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ACodecMainPKey" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ACodecMainPKey" msprop:Generator_ColumnPropNameInRow="ACodecMainPKey" msprop:Generator_ColumnVarNameInTable="columnACodecMainPKey" msprop:Generator_ColumnPropNameInTable="ACodecMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CondMainPKey" msprop:Generator_UserColumnName="CondMainPKey" msprop:Generator_ColumnPropNameInRow="CondMainPKey" msprop:Generator_ColumnVarNameInTable="columnCondMainPKey" msprop:Generator_ColumnPropNameInTable="CondMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RelDirectorPKey" msprop:Generator_UserColumnName="RelDirectorPKey" msprop:Generator_ColumnPropNameInRow="RelDirectorPKey" msprop:Generator_ColumnVarNameInTable="columnRelDirectorPKey" msprop:Generator_ColumnPropNameInTable="RelDirectorPKeyColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SeriesDetailsView" msprop:Generator_UserTableName="SeriesDetailsView" msprop:Generator_RowDeletedName="SeriesDetailsViewRowDeleted" msprop:Generator_RowChangedName="SeriesDetailsViewRowChanged" msprop:Generator_RowClassName="SeriesDetailsViewRow" msprop:Generator_RowChangingName="SeriesDetailsViewRowChanging" msprop:Generator_RowEvArgName="SeriesDetailsViewRowChangeEvent" msprop:Generator_RowEvHandlerName="SeriesDetailsViewRowChangeEventHandler" msprop:Generator_TableClassName="SeriesDetailsViewDataTable" msprop:Generator_TableVarName="tableSeriesDetailsView" msprop:Generator_RowDeletingName="SeriesDetailsViewRowDeleting" msprop:Generator_TablePropName="SeriesDetailsView">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PKey" msprop:Generator_UserColumnName="PKey" msprop:Generator_ColumnPropNameInRow="PKey" msprop:Generator_ColumnVarNameInTable="columnPKey" msprop:Generator_ColumnPropNameInTable="PKeyColumn" type="xs:int" />
              <xs:element name="StagePKey" msprop:Generator_UserColumnName="StagePKey" msprop:Generator_ColumnPropNameInRow="StagePKey" msprop:Generator_ColumnVarNameInTable="columnStagePKey" msprop:Generator_ColumnPropNameInTable="StagePKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SerialNo" msprop:Generator_UserColumnName="SerialNo" msprop:Generator_ColumnPropNameInRow="SerialNo" msprop:Generator_ColumnVarNameInTable="columnSerialNo" msprop:Generator_ColumnPropNameInTable="SerialNoColumn" type="xs:int" />
              <xs:element name="tmpSeen" msprop:Generator_UserColumnName="tmpSeen" msprop:Generator_ColumnPropNameInRow="tmpSeen" msprop:Generator_ColumnVarNameInTable="columntmpSeen" msprop:Generator_ColumnPropNameInTable="tmpSeenColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="tmpLoaned" msprop:Generator_UserColumnName="tmpLoaned" msprop:Generator_ColumnPropNameInRow="tmpLoaned" msprop:Generator_ColumnVarNameInTable="columntmpLoaned" msprop:Generator_ColumnPropNameInTable="tmpLoanedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AlternateTitle" msprop:Generator_UserColumnName="AlternateTitle" msprop:Generator_ColumnPropNameInRow="AlternateTitle" msprop:Generator_ColumnVarNameInTable="columnAlternateTitle" msprop:Generator_ColumnPropNameInTable="AlternateTitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Seen" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Seen" msprop:Generator_ColumnPropNameInRow="Seen" msprop:Generator_ColumnVarNameInTable="columnSeen" msprop:Generator_ColumnPropNameInTable="SeenColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInTable="RatingColumn" type="xs:double" minOccurs="0" />
              <xs:element name="MyRating" msprop:Generator_UserColumnName="MyRating" msprop:Generator_ColumnPropNameInRow="MyRating" msprop:Generator_ColumnVarNameInTable="columnMyRating" msprop:Generator_ColumnPropNameInTable="MyRatingColumn" type="xs:double" minOccurs="0" />
              <xs:element name="tmpDirector" msprop:Generator_UserColumnName="tmpDirector" msprop:Generator_ColumnPropNameInRow="tmpDirector" msprop:Generator_ColumnVarNameInTable="columntmpDirector" msprop:Generator_ColumnPropNameInTable="tmpDirectorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Director" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Director" msprop:Generator_ColumnPropNameInRow="Director" msprop:Generator_ColumnVarNameInTable="columnDirector" msprop:Generator_ColumnPropNameInTable="DirectorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Volume" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Volume" msprop:Generator_ColumnPropNameInRow="Volume" msprop:Generator_ColumnVarNameInTable="columnVolume" msprop:Generator_ColumnPropNameInTable="VolumeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Genre" msprop:Generator_UserColumnName="Genre" msprop:Generator_ColumnPropNameInRow="Genre" msprop:Generator_ColumnVarNameInTable="columnGenre" msprop:Generator_ColumnPropNameInTable="GenreColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Studio" msprop:Generator_UserColumnName="Studio" msprop:Generator_ColumnPropNameInRow="Studio" msprop:Generator_ColumnVarNameInTable="columnStudio" msprop:Generator_ColumnPropNameInTable="StudioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Collection" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Collection" msprop:Generator_ColumnPropNameInRow="Collection" msprop:Generator_ColumnVarNameInTable="columnCollection" msprop:Generator_ColumnPropNameInTable="CollectionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cast" msprop:Generator_UserColumnName="Cast" msprop:Generator_ColumnPropNameInRow="Cast" msprop:Generator_ColumnVarNameInTable="columnCast" msprop:Generator_ColumnPropNameInTable="CastColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Plot" msprop:Generator_UserColumnName="Plot" msprop:Generator_ColumnPropNameInRow="Plot" msprop:Generator_ColumnVarNameInTable="columnPlot" msprop:Generator_ColumnPropNameInTable="PlotColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Notes" msprop:Generator_UserColumnName="Notes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInTable="NotesColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Poster" msprop:Generator_UserColumnName="Poster" msprop:Generator_ColumnPropNameInRow="Poster" msprop:Generator_ColumnVarNameInTable="columnPoster" msprop:Generator_ColumnPropNameInTable="PosterColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PosterLocation" msprop:Generator_UserColumnName="PosterLocation" msprop:Generator_ColumnPropNameInRow="PosterLocation" msprop:Generator_ColumnVarNameInTable="columnPosterLocation" msprop:Generator_ColumnPropNameInTable="PosterLocationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Classification" msprop:Generator_UserColumnName="Classification" msprop:Generator_ColumnPropNameInRow="Classification" msprop:Generator_ColumnVarNameInTable="columnClassification" msprop:Generator_ColumnPropNameInTable="ClassificationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nDiscs" msprop:Generator_UserColumnName="nDiscs" msprop:Generator_ColumnPropNameInRow="nDiscs" msprop:Generator_ColumnVarNameInTable="columnnDiscs" msprop:Generator_ColumnPropNameInTable="nDiscsColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RunTime" msprop:Generator_UserColumnName="RunTime" msprop:Generator_ColumnPropNameInRow="RunTime" msprop:Generator_ColumnVarNameInTable="columnRunTime" msprop:Generator_ColumnPropNameInTable="RunTimeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Layer" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Layer" msprop:Generator_ColumnPropNameInRow="Layer" msprop:Generator_ColumnVarNameInTable="columnLayer" msprop:Generator_ColumnPropNameInTable="LayerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Colour" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Colour" msprop:Generator_ColumnPropNameInRow="Colour" msprop:Generator_ColumnVarNameInTable="columnColour" msprop:Generator_ColumnPropNameInTable="ColourColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Region" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Region" msprop:Generator_ColumnPropNameInRow="_Region" msprop:Generator_ColumnVarNameInTable="columnRegion" msprop:Generator_ColumnPropNameInTable="RegionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Medium" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Medium" msprop:Generator_ColumnPropNameInRow="Medium" msprop:Generator_ColumnVarNameInTable="columnMedium" msprop:Generator_ColumnPropNameInTable="MediumColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VCodec" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VCodec" msprop:Generator_ColumnPropNameInRow="VCodec" msprop:Generator_ColumnVarNameInTable="columnVCodec" msprop:Generator_ColumnPropNameInTable="VCodecColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ACodec" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ACodec" msprop:Generator_ColumnPropNameInRow="ACodec" msprop:Generator_ColumnVarNameInTable="columnACodec" msprop:Generator_ColumnPropNameInTable="ACodecColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Condition" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Condition" msprop:Generator_ColumnPropNameInRow="Condition" msprop:Generator_ColumnVarNameInTable="columnCondition" msprop:Generator_ColumnPropNameInTable="ConditionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMDbLink" msdata:ReadOnly="true" msprop:Generator_UserColumnName="IMDbLink" msprop:Generator_ColumnPropNameInRow="IMDbLink" msprop:Generator_ColumnVarNameInTable="columnIMDbLink" msprop:Generator_ColumnPropNameInTable="IMDbLinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMDbTrailerLink" msdata:ReadOnly="true" msprop:Generator_UserColumnName="IMDbTrailerLink" msprop:Generator_ColumnPropNameInRow="IMDbTrailerLink" msprop:Generator_ColumnVarNameInTable="columnIMDbTrailerLink" msprop:Generator_ColumnPropNameInTable="IMDbTrailerLinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OfficialSite" msdata:ReadOnly="true" msprop:Generator_UserColumnName="OfficialSite" msprop:Generator_ColumnPropNameInRow="OfficialSite" msprop:Generator_ColumnVarNameInTable="columnOfficialSite" msprop:Generator_ColumnPropNameInTable="OfficialSiteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WikipediaLink" msdata:ReadOnly="true" msprop:Generator_UserColumnName="WikipediaLink" msprop:Generator_ColumnPropNameInRow="WikipediaLink" msprop:Generator_ColumnVarNameInTable="columnWikipediaLink" msprop:Generator_ColumnPropNameInTable="WikipediaLinkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MyReviews" msprop:Generator_UserColumnName="MyReviews" msprop:Generator_ColumnPropNameInRow="MyReviews" msprop:Generator_ColumnVarNameInTable="columnMyReviews" msprop:Generator_ColumnPropNameInTable="MyReviewsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VolumeMainPKey" msprop:Generator_UserColumnName="VolumeMainPKey" msprop:Generator_ColumnPropNameInRow="VolumeMainPKey" msprop:Generator_ColumnVarNameInTable="columnVolumeMainPKey" msprop:Generator_ColumnPropNameInTable="VolumeMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CollectionMainPKey" msprop:Generator_UserColumnName="CollectionMainPKey" msprop:Generator_ColumnPropNameInRow="CollectionMainPKey" msprop:Generator_ColumnVarNameInTable="columnCollectionMainPKey" msprop:Generator_ColumnPropNameInTable="CollectionMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="LayerMainPKey" msprop:Generator_UserColumnName="LayerMainPKey" msprop:Generator_ColumnPropNameInRow="LayerMainPKey" msprop:Generator_ColumnVarNameInTable="columnLayerMainPKey" msprop:Generator_ColumnPropNameInTable="LayerMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ColourMainPKey" msprop:Generator_UserColumnName="ColourMainPKey" msprop:Generator_ColumnPropNameInRow="ColourMainPKey" msprop:Generator_ColumnVarNameInTable="columnColourMainPKey" msprop:Generator_ColumnPropNameInTable="ColourMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RegionMainPKey" msprop:Generator_UserColumnName="RegionMainPKey" msprop:Generator_ColumnPropNameInRow="RegionMainPKey" msprop:Generator_ColumnVarNameInTable="columnRegionMainPKey" msprop:Generator_ColumnPropNameInTable="RegionMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MediumMainPKey" msprop:Generator_UserColumnName="MediumMainPKey" msprop:Generator_ColumnPropNameInRow="MediumMainPKey" msprop:Generator_ColumnVarNameInTable="columnMediumMainPKey" msprop:Generator_ColumnPropNameInTable="MediumMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="VCodecMainPKey" msprop:Generator_UserColumnName="VCodecMainPKey" msprop:Generator_ColumnPropNameInRow="VCodecMainPKey" msprop:Generator_ColumnVarNameInTable="columnVCodecMainPKey" msprop:Generator_ColumnPropNameInTable="VCodecMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ACodecMainPKey" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ACodecMainPKey" msprop:Generator_ColumnPropNameInRow="ACodecMainPKey" msprop:Generator_ColumnVarNameInTable="columnACodecMainPKey" msprop:Generator_ColumnPropNameInTable="ACodecMainPKeyColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CondMainPKey" msprop:Generator_UserColumnName="CondMainPKey" msprop:Generator_ColumnPropNameInRow="CondMainPKey" msprop:Generator_ColumnVarNameInTable="columnCondMainPKey" msprop:Generator_ColumnPropNameInTable="CondMainPKeyColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SeriesDetailsView" />
      <xs:field xpath="mstns:PKey" />
    </xs:unique>
  </xs:element>
</xs:schema>